DBC-Zorgproducten per jaar, specialisme, diagnose

Dataset statistics

Number of variables	14
Number of observations	260682
Missing cells	39793
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	27.8 MiB
Average record size in memory	112.0 B

Variable types

Categorical	4
DateTime	1
Numeric	9

Warnings

`VERSIE` has constant value "1.0"	Constant
`DATUM_BESTAND` has constant value "2021-02-09"	Constant
`PEILDATUM` has constant value "2021-02-01"	Constant
`TYPERENDE_DIAGNOSE_CD` has a high cardinality: 1766 distinct values	High cardinality
`AANTAL_PAT_PER_ZPD` is highly correlated with `AANTAL_SUBTRAJECT_PER_ZPD`	High correlation
`AANTAL_SUBTRAJECT_PER_ZPD` is highly correlated with `AANTAL_PAT_PER_ZPD`	High correlation
`AANTAL_PAT_PER_DIAG` is highly correlated with `AANTAL_SUBTRAJECT_PER_DIAG`	High correlation
`AANTAL_SUBTRAJECT_PER_DIAG` is highly correlated with `AANTAL_PAT_PER_DIAG`	High correlation
`AANTAL_PAT_PER_SPC` is highly correlated with `AANTAL_SUBTRAJECT_PER_SPC`	High correlation
`AANTAL_SUBTRAJECT_PER_SPC` is highly correlated with `AANTAL_PAT_PER_SPC`	High correlation
`PEILDATUM` is highly correlated with `DATUM_BESTAND` and 1 other fields	High correlation
`DATUM_BESTAND` is highly correlated with `PEILDATUM` and 1 other fields	High correlation
`VERSIE` is highly correlated with `PEILDATUM` and 1 other fields	High correlation
`GEMIDDELDE_VERKOOPPRIJS` has 39793 (15.3%) missing values	Missing
`AANTAL_SUBTRAJECT_PER_ZPD` is highly skewed (γ1 = 21.01127808)	Skewed

Reproduction

Analysis started	2021-02-23 10:28:29.752753
Analysis finished	2021-02-23 10:29:01.335022
Duration	31.58 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

VERSIE
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

1.0	260682

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	782046
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Value	Count	Frequency (%)
1.0	260682	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
1.0	260682	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	260682	33.3%
.	260682	33.3%
0	260682	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	521364	66.7%
Other Punctuation	260682	33.3%

Most frequent character per category

Value	Count	Frequency (%)
1	260682	50.0%
0	260682	50.0%

Value	Count	Frequency (%)
.	260682	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	782046	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	260682	33.3%
.	260682	33.3%
0	260682	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	782046	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	260682	33.3%
.	260682	33.3%
0	260682	33.3%

DATUM_BESTAND
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

2021-02-09	260682

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	2606820
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021-02-09
2nd row	2021-02-09
3rd row	2021-02-09
4th row	2021-02-09
5th row	2021-02-09

Value	Count	Frequency (%)
2021-02-09	260682	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-02-09	260682	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	782046	30.0%
0	782046	30.0%
-	521364	20.0%
1	260682	10.0%
9	260682	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2085456	80.0%
Dash Punctuation	521364	20.0%

Most frequent character per category

Value	Count	Frequency (%)
2	782046	37.5%
0	782046	37.5%
1	260682	12.5%
9	260682	12.5%

Value	Count	Frequency (%)
-	521364	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2606820	100.0%

Most frequent character per script

Value	Count	Frequency (%)
2	782046	30.0%
0	782046	30.0%
-	521364	20.0%
1	260682	10.0%
9	260682	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2606820	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	782046	30.0%
0	782046	30.0%
-	521364	20.0%
1	260682	10.0%
9	260682	10.0%

PEILDATUM
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

2021-02-01	260682

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	2606820
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021-02-01
2nd row	2021-02-01
3rd row	2021-02-01
4th row	2021-02-01
5th row	2021-02-01

Value	Count	Frequency (%)
2021-02-01	260682	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-02-01	260682	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	782046	30.0%
0	782046	30.0%
1	521364	20.0%
-	521364	20.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2085456	80.0%
Dash Punctuation	521364	20.0%

Most frequent character per category

Value	Count	Frequency (%)
2	782046	37.5%
0	782046	37.5%
1	521364	25.0%

Value	Count	Frequency (%)
-	521364	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2606820	100.0%

Most frequent character per script

Value	Count	Frequency (%)
2	782046	30.0%
0	782046	30.0%
1	521364	20.0%
-	521364	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2606820	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	782046	30.0%
0	782046	30.0%
1	521364	20.0%
-	521364	20.0%

JAAR
Date

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

Minimum	2012-01-01 00:00:00
Maximum	2021-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=10)

BEHANDELEND_SPECIALISME_CD
Real number (ℝ_≥0)

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	421.425108
Minimum	301
Maximum	8418
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	301
5-th percentile	302
Q1	305
median	313
Q3	322
95-th percentile	335
Maximum	8418
Range	8117
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	919.5893703
Coefficient of variation (CV)	2.182094405
Kurtosis	71.47442542
Mean	421.425108
Median Absolute Deviation (MAD)	8
Skewness	8.564862963
Sum	109857940
Variance	845644.6101
Monotocity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
305	37016	14.2%
313	33709	12.9%
303	29972	11.5%
330	20832	8.0%
316	17819	6.8%
308	13506	5.2%
306	10895	4.2%
324	10872	4.2%
301	10517	4.0%
304	8482	3.3%
Other values (17)	67062	25.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
301	10517	4.0%
302	5659	2.2%
303	29972	11.5%
304	8482	3.3%
305	37016	14.2%

Value	Count	Frequency (%)
8418	3395	1.3%
1900	171	0.1%
390	672	0.3%
389	2810	1.1%
362	3925	1.5%

TYPERENDE_DIAGNOSE_CD
Categorical

HIGH CARDINALITY

Distinct	1766
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

101	1090
402	1064
403	1037
301	1030
203	976
Other values (1761)	255485

Length

Max length	4
Median length	3
Mean length	3.350776041
Min length	2

Characters and Unicode

Total characters	873487
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	559
2nd row	557
3rd row	554
4th row	559
5th row	554

Value	Count	Frequency (%)
101	1090	0.4%
402	1064	0.4%
403	1037	0.4%
301	1030	0.4%
203	976	0.4%
201	971	0.4%
401	873	0.3%
404	862	0.3%
802	852	0.3%
409	844	0.3%
Other values (1756)	251083	96.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
101	1090	0.4%
402	1064	0.4%
403	1037	0.4%
301	1030	0.4%
203	976	0.4%
201	971	0.4%
401	873	0.3%
404	862	0.3%
802	852	0.3%
409	844	0.3%
Other values (1756)	251083	96.3%

Most occurring characters

Value	Count	Frequency (%)
1	167361	19.2%
0	159671	18.3%
2	115731	13.2%
3	94856	10.9%
5	66917	7.7%
9	63228	7.2%
4	62258	7.1%
7	51430	5.9%
6	45768	5.2%
8	37475	4.3%
Other values (15)	8792	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	864695	99.0%
Uppercase Letter	8792	1.0%

Most frequent character per category

Value	Count	Frequency (%)
G	1635	18.6%
M	1467	16.7%
B	1051	12.0%
E	758	8.6%
Z	694	7.9%
D	599	6.8%
A	578	6.6%
F	563	6.4%
C	291	3.3%
K	282	3.2%
Other values (5)	874	9.9%

Value	Count	Frequency (%)
1	167361	19.4%
0	159671	18.5%
2	115731	13.4%
3	94856	11.0%
5	66917	7.7%
9	63228	7.3%
4	62258	7.2%
7	51430	5.9%
6	45768	5.3%
8	37475	4.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	864695	99.0%
Latin	8792	1.0%

Most frequent character per script

Value	Count	Frequency (%)
G	1635	18.6%
M	1467	16.7%
B	1051	12.0%
E	758	8.6%
Z	694	7.9%
D	599	6.8%
A	578	6.6%
F	563	6.4%
C	291	3.3%
K	282	3.2%
Other values (5)	874	9.9%

Value	Count	Frequency (%)
1	167361	19.4%
0	159671	18.5%
2	115731	13.4%
3	94856	11.0%
5	66917	7.7%
9	63228	7.3%
4	62258	7.2%
7	51430	5.9%
6	45768	5.3%
8	37475	4.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	873487	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	167361	19.2%
0	159671	18.3%
2	115731	13.2%
3	94856	10.9%
5	66917	7.7%
9	63228	7.2%
4	62258	7.1%
7	51430	5.9%
6	45768	5.2%
8	37475	4.3%
Other values (15)	8792	1.0%

ZORGPRODUCT_CD
Real number (ℝ_≥0)

Distinct	5893
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	441790049.6
Minimum	10501002
Maximum	998418081
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	10501002
5-th percentile	28999037
Q1	99799061
median	149599030
Q3	990004004
95-th percentile	990416051
Maximum	998418081
Range	987917079
Interquartile range (IQR)	890204943

Descriptive statistics

Standard deviation	429303066.6
Coefficient of variation (CV)	0.9717354817
Kurtosis	-1.742027437
Mean	441790049.6
Median Absolute Deviation (MAD)	119700019
Skewness	0.4627499483
Sum	1.151667137 × 10¹⁴
Variance	1.84301123 × 10¹⁷
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
990004009	1898	0.7%
990004007	1869	0.7%
990003004	1868	0.7%
990004006	1510	0.6%
990356076	1340	0.5%
990356073	1242	0.5%
990003007	1197	0.5%
131999228	1139	0.4%
131999164	1126	0.4%
199299013	1085	0.4%
Other values (5883)	246408	94.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10501002	6	< 0.1%
10501003	9	< 0.1%
10501004	9	< 0.1%
10501005	9	< 0.1%
10501007	3	< 0.1%

Value	Count	Frequency (%)
998418081	127	< 0.1%
998418080	113	< 0.1%
998418079	33	< 0.1%
998418077	6	< 0.1%
998418076	6	< 0.1%

AANTAL_PAT_PER_ZPD
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9007
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	508.3764318
Minimum	1
Maximum	154837
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	14
Q3	103
95-th percentile	1727
Maximum	154837
Range	154836
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	3126.057126
Coefficient of variation (CV)	6.14909923
Kurtosis	389.7948348
Mean	508.3764318
Median Absolute Deviation (MAD)	13
Skewness	16.44053249
Sum	132524585
Variance	9772233.152
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	42850	16.4%
2	21110	8.1%
3	13723	5.3%
4	10169	3.9%
5	7889	3.0%
6	6628	2.5%
7	5555	2.1%
8	4714	1.8%
9	4293	1.6%
10	3785	1.5%
Other values (8997)	139966	53.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	42850	16.4%
2	21110	8.1%
3	13723	5.3%
4	10169	3.9%
5	7889	3.0%

Value	Count	Frequency (%)
154837	1	< 0.1%
154823	1	< 0.1%
153884	1	< 0.1%
144702	1	< 0.1%
114354	1	< 0.1%

AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	9624
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	594.1707483
Minimum	1
Maximum	239907
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	15
Q3	112
95-th percentile	1957
Maximum	239907
Range	239906
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	3958.105553
Coefficient of variation (CV)	6.661562463
Kurtosis	707.3255652
Mean	594.1707483
Median Absolute Deviation (MAD)	14
Skewness	21.01127808
Sum	154889619
Variance	15666599.57
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	41308	15.8%
2	20771	8.0%
3	13580	5.2%
4	9990	3.8%
5	7798	3.0%
6	6631	2.5%
7	5509	2.1%
8	4661	1.8%
9	4216	1.6%
10	3839	1.5%
Other values (9614)	142379	54.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	41308	15.8%
2	20771	8.0%
3	13580	5.2%
4	9990	3.8%
5	7798	3.0%

Value	Count	Frequency (%)
239907	1	< 0.1%
232484	1	< 0.1%
231318	1	< 0.1%
227657	1	< 0.1%
221390	1	< 0.1%

AANTAL_PAT_PER_DIAG
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	7868
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7669.618067
Minimum	1
Maximum	214611
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	412
median	1725
Q3	6409
95-th percentile	36788
Maximum	214611
Range	214610
Interquartile range (IQR)	5997

Descriptive statistics

Standard deviation	17662.42092
Coefficient of variation (CV)	2.302907493
Kurtosis	32.77559046
Mean	7669.618067
Median Absolute Deviation (MAD)	1564
Skewness	4.986479708
Sum	1999331377
Variance	311961112.6
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	450	0.2%
12	374	0.1%
17	372	0.1%
25	370	0.1%
37	360	0.1%
23	360	0.1%
19	355	0.1%
26	354	0.1%
6	345	0.1%
15	337	0.1%
Other values (7858)	257005	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	265	0.1%
2	281	0.1%
3	291	0.1%
4	321	0.1%
5	276	0.1%

Value	Count	Frequency (%)
214611	23	< 0.1%
212136	25	< 0.1%
209820	19	< 0.1%
208368	17	< 0.1%
204239	17	< 0.1%

AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8704
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10818.26704
Minimum	1
Maximum	345671
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	1
5-th percentile	55
Q1	544
median	2374
Q3	8944
95-th percentile	51444
Maximum	345671
Range	345670
Interquartile range (IQR)	8400

Descriptive statistics

Standard deviation	25732.01422
Coefficient of variation (CV)	2.378570811
Kurtosis	37.08158505
Mean	10818.26704
Median Absolute Deviation (MAD)	2172
Skewness	5.266797295
Sum	2820127489
Variance	662136555.6
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38	343	0.1%
24	335	0.1%
13	306	0.1%
25	292	0.1%
17	291	0.1%
18	291	0.1%
10	289	0.1%
48	279	0.1%
20	276	0.1%
93	270	0.1%
Other values (8694)	257710	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	215	0.1%
2	219	0.1%
3	247	0.1%
4	257	0.1%
5	236	0.1%

Value	Count	Frequency (%)
345671	25	< 0.1%
343141	23	< 0.1%
340525	19	< 0.1%
323714	20	< 0.1%
305771	17	< 0.1%

AANTAL_PAT_PER_SPC
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	243
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	670993.5003
Minimum	38
Maximum	1489512
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	38
5-th percentile	44662
Q1	286650
median	744724
Q3	995517
95-th percentile	1345280
Maximum	1489512
Range	1489474
Interquartile range (IQR)	708867

Descriptive statistics

Standard deviation	413081.1368
Coefficient of variation (CV)	0.6156261374
Kurtosis	-1.07409858
Mean	670993.5003
Median Absolute Deviation (MAD)	313635
Skewness	0.0473962123
Sum	1.749159277 × 10¹¹
Variance	1.706360256 × 10¹¹
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
880967	5102	2.0%
874259	4354	1.7%
843996	4348	1.7%
893043	4332	1.7%
874956	4271	1.6%
833887	4138	1.6%
1084230	3891	1.5%
1063771	3851	1.5%
1077489	3847	1.5%
1038995	3810	1.5%
Other values (233)	218738	83.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
38	1	< 0.1%
975	81	< 0.1%
1426	125	< 0.1%
1953	131	0.1%
2584	173	0.1%

Value	Count	Frequency (%)
1489512	2976	1.1%
1450634	3054	1.2%
1421871	3564	1.4%
1345280	3543	1.4%
1332919	3546	1.4%

AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	243
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1061710.004
Minimum	73
Maximum	2582832
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	73
5-th percentile	52194
Q1	483178
median	1014348
Q3	1729123
95-th percentile	2455216
Maximum	2582832
Range	2582759
Interquartile range (IQR)	1245945

Descriptive statistics

Standard deviation	715343.2068
Coefficient of variation (CV)	0.6737651563
Kurtosis	-0.8721171883
Mean	1061710.004
Median Absolute Deviation (MAD)	643653
Skewness	0.3279760176
Sum	2.767686873 × 10¹¹
Variance	5.117159035 × 10¹¹
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1211812	5102	2.0%
1281547	4354	1.7%
1216286	4348	1.7%
1313000	4332	1.7%
1290095	4271	1.6%
1227553	4138	1.6%
2557237	3891	1.5%
2489097	3851	1.5%
2582832	3847	1.5%
2066422	3810	1.5%
Other values (233)	218738	83.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
73	1	< 0.1%
1069	81	< 0.1%
1645	125	< 0.1%
2237	131	0.1%
2924	173	0.1%

Value	Count	Frequency (%)
2582832	3847	1.5%
2557237	3891	1.5%
2489097	3851	1.5%
2455216	3810	1.5%
2184710	3757	1.4%

GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ_≥0)

MISSING

Distinct	3176
Distinct (%)	1.4%
Missing	39793
Missing (%)	15.3%
Infinite	0
Infinite (%)	0.0%

Mean	3510.165196
Minimum	60
Maximum	287220
Zeros	0
Zeros (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	60
5-th percentile	140
Q1	465
median	1235
Q3	4040
95-th percentile	13275
Maximum	287220
Range	287160
Interquartile range (IQR)	3575

Descriptive statistics

Standard deviation	6590.50629
Coefficient of variation (CV)	1.877548754
Kurtosis	169.2048005
Mean	3510.165196
Median Absolute Deviation (MAD)	1005
Skewness	7.857079711
Sum	775356880
Variance	43434773.15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
105	1850	0.7%
160	1810	0.7%
110	1465	0.6%
180	1380	0.5%
500	1325	0.5%
120	1317	0.5%
185	1293	0.5%
145	1262	0.5%
300	1250	0.5%
140	1212	0.5%
Other values (3166)	206725	79.3%
(Missing)	39793	15.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
60	2	< 0.1%
70	226	0.1%
75	75	< 0.1%
80	361	0.1%
85	908	0.3%

Value	Count	Frequency (%)
287220	8	< 0.1%
148910	3	< 0.1%
142855	4	< 0.1%
122155	4	< 0.1%
116765	3	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
0	1.0	2021-02-09	2021-02-01	2016-01-01	301	559	70401002	58	60	4445	5485	1191108	1910104	1425.0
1	1.0	2021-02-09	2021-02-01	2016-01-01	301	557	70401002	15	15	44290	56006	1191108	1910104	1425.0
2	1.0	2021-02-09	2021-02-01	2016-01-01	301	554	70401002	12596	14295	200180	288419	1191108	1910104	1425.0
3	1.0	2021-02-09	2021-02-01	2016-01-01	301	559	70401003	6	6	4445	5485	1191108	1910104	625.0
4	1.0	2021-02-09	2021-02-01	2016-01-01	301	554	70401003	97	98	200180	288419	1191108	1910104	625.0
5	1.0	2021-02-09	2021-02-01	2016-01-01	301	557	70401003	10	10	44290	56006	1191108	1910104	625.0
6	1.0	2021-02-09	2021-02-01	2016-01-01	301	557	70401004	4	4	44290	56006	1191108	1910104	NaN
7	1.0	2021-02-09	2021-02-01	2016-01-01	301	559	70401004	10	10	4445	5485	1191108	1910104	NaN
8	1.0	2021-02-09	2021-02-01	2016-01-01	301	554	70401004	69	70	200180	288419	1191108	1910104	NaN
9	1.0	2021-02-09	2021-02-01	2016-01-01	301	554	70401006	2	2	200180	288419	1191108	1910104	NaN

Last rows

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
260672	1.0	2021-02-09	2021-02-01	2016-01-01	8418	304	998418081	1	1	523	538	42595	45568	NaN
260673	1.0	2021-02-09	2021-02-01	2016-01-01	8418	305	998418081	2	2	405	421	42595	45568	NaN
260674	1.0	2021-02-09	2021-02-01	2016-01-01	8418	202	998418081	3	3	700	734	42595	45568	NaN
260675	1.0	2021-02-09	2021-02-01	2016-01-01	8418	503	998418081	11	11	3533	3710	42595	45568	NaN
260676	1.0	2021-02-09	2021-02-01	2016-01-01	8418	303	998418081	22	22	6223	6389	42595	45568	NaN
260677	1.0	2021-02-09	2021-02-01	2016-01-01	8418	309	998418081	8	8	2236	2303	42595	45568	NaN
260678	1.0	2021-02-09	2021-02-01	2016-01-01	8418	203	998418081	2	2	1800	1849	42595	45568	NaN
260679	1.0	2021-02-09	2021-02-01	2016-01-01	8418	504	998418081	17	17	4554	4740	42595	45568	NaN
260680	1.0	2021-02-09	2021-02-01	2016-01-01	8418	402	998418081	10	10	742	872	42595	45568	NaN
260681	1.0	2021-02-09	2021-02-01	2016-01-01	8418	209	998418081	2	2	391	407	42595	45568	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows